load data
truncate
into table CRST_PER_ALL_PEOPLE_F
fields terminated by "	"
trailing nullcols 
( PERSON_ID                      ,
  EFFECTIVE_START_DATE           Date "YYYYMMDD HH24:MI:SS",
  EFFECTIVE_END_DATE             Date "YYYYMMDD HH24:MI:SS",
  BUSINESS_GROUP_ID              ,
  PERSON_TYPE_ID                 ,
  LAST_NAME                      ,
  START_DATE                     Date "YYYYMMDD HH24:MI:SS",
  APPLICANT_NUMBER               ,
  COMMENT_ID                     ,
  CURRENT_APPLICANT_FLAG         ,
  CURRENT_EMP_OR_APL_FLAG        ,
  CURRENT_EMPLOYEE_FLAG          ,
  DATE_EMPLOYEE_DATA_VERIFIED    Date "YYYYMMDD HH24:MI:SS",
  DATE_OF_BIRTH                  Date "YYYYMMDD HH24:MI:SS",
  EMAIL_ADDRESS                  ,
  EMPLOYEE_NUMBER                ,
  EXPENSE_CHECK_SEND_TO_ADDRESS  ,
  FIRST_NAME                     ,
  FULL_NAME                      ,
  KNOWN_AS                       ,
  MARITAL_STATUS                 ,
  MIDDLE_NAMES                   ,
  NATIONALITY                    ,
  NATIONAL_IDENTIFIER            ,
  PREVIOUS_LAST_NAME             ,
  REGISTERED_DISABLED_FLAG       ,
  SEX                            ,
  TITLE                          ,
  VENDOR_ID                      ,
  WORK_TELEPHONE                 ,
  REQUEST_ID                     ,
  PROGRAM_APPLICATION_ID         ,
  PROGRAM_ID                     ,
  PROGRAM_UPDATE_DATE            Date "YYYYMMDD HH24:MI:SS",
  ATTRIBUTE_CATEGORY             ,
  ATTRIBUTE1                     ,
  ATTRIBUTE2                     ,
  ATTRIBUTE3                     ,
  ATTRIBUTE4                     ,
  ATTRIBUTE5                     ,
  ATTRIBUTE6                     ,
  ATTRIBUTE7                     ,
  ATTRIBUTE8                     ,
  ATTRIBUTE9                     ,
  ATTRIBUTE10                    ,
  ATTRIBUTE11                    ,
  ATTRIBUTE12                    ,
  ATTRIBUTE13                    ,
  ATTRIBUTE14                    ,
  ATTRIBUTE15                    ,
  ATTRIBUTE16                    ,
  ATTRIBUTE17                    ,
  ATTRIBUTE18                    ,
  ATTRIBUTE19                    ,
  ATTRIBUTE20                    ,
  ATTRIBUTE21                    ,
  ATTRIBUTE22                    ,
  ATTRIBUTE23                    ,
  ATTRIBUTE24                    ,
  ATTRIBUTE25                    ,
  ATTRIBUTE26                    ,
  ATTRIBUTE27                    ,
  ATTRIBUTE28                    ,
  ATTRIBUTE29                    ,
  ATTRIBUTE30                    ,
  LAST_UPDATE_DATE               Date "YYYYMMDD HH24:MI:SS",
  LAST_UPDATED_BY                ,
  LAST_UPDATE_LOGIN              ,
  CREATED_BY                     ,
  CREATION_DATE                  Date "YYYYMMDD HH24:MI:SS",
  PER_INFORMATION_CATEGORY       ,
  PER_INFORMATION1               ,
  PER_INFORMATION2               ,
  PER_INFORMATION3               ,
  PER_INFORMATION4               ,
  PER_INFORMATION5               ,
  PER_INFORMATION6               ,
  PER_INFORMATION7               ,
  PER_INFORMATION8               ,
  PER_INFORMATION9               ,
  PER_INFORMATION10              ,
  PER_INFORMATION11              ,
  PER_INFORMATION12              ,
  PER_INFORMATION13              ,
  PER_INFORMATION14              ,
  PER_INFORMATION15              ,
  PER_INFORMATION16              ,
  PER_INFORMATION17              ,
  PER_INFORMATION18              ,
  PER_INFORMATION19              ,
  PER_INFORMATION20              ,
  BACKGROUND_CHECK_STATUS        ,
  BACKGROUND_DATE_CHECK          Date "YYYYMMDD HH24:MI:SS",
  BLOOD_TYPE                     ,
  CORRESPONDENCE_LANGUAGE        ,
  FAST_PATH_EMPLOYEE             ,
  FTE_CAPACITY                   ,
  HOLD_APPLICANT_DATE_UNTIL      Date "YYYYMMDD HH24:MI:SS",
  HONORS                         ,
  INTERNAL_LOCATION              ,
  LAST_MEDICAL_TEST_BY           ,
  LAST_MEDICAL_TEST_DATE         Date "YYYYMMDD HH24:MI:SS",
  MAILSTOP                       ,
  OFFICE_NUMBER                  ,
  ON_MILITARY_SERVICE            ,
  ORDER_NAME                     ,
  PRE_NAME_ADJUNCT               ,
  PROJECTED_START_DATE           Date "YYYYMMDD HH24:MI:SS",
  REHIRE_AUTHORIZOR              ,
  REHIRE_RECOMMENDATION          ,
  RESUME_EXISTS                  ,
  RESUME_LAST_UPDATED            Date "YYYYMMDD HH24:MI:SS",
  SECOND_PASSPORT_EXISTS         ,
  STUDENT_STATUS                 ,
  SUFFIX                         ,
  WORK_SCHEDULE                  ,
  PER_INFORMATION21              ,
  PER_INFORMATION22              ,
  PER_INFORMATION23              ,
  PER_INFORMATION24              ,
  PER_INFORMATION25              ,
  PER_INFORMATION26              ,
  PER_INFORMATION27              ,
  PER_INFORMATION28              ,
  PER_INFORMATION29              ,
  PER_INFORMATION30              ,
  OBJECT_VERSION_NUMBER          ,
  DATE_OF_DEATH                  Date "YYYYMMDD HH24:MI:SS",
  REHIRE_REASON                  ,
  COORD_BEN_MED_PLN_NO           ,
  COORD_BEN_NO_CVG_FLAG          ,
  DPDNT_ADOPTION_DATE            Date "YYYYMMDD HH24:MI:SS",
  DPDNT_VLNTRY_SVCE_FLAG         ,
  RECEIPT_OF_DEATH_CERT_DATE     Date "YYYYMMDD HH24:MI:SS",
  USES_TOBACCO_FLAG              ,
  BENEFIT_GROUP_ID               ,
  ORIGINAL_DATE_OF_HIRE          Date "YYYYMMDD HH24:MI:SS",
  TOWN_OF_BIRTH                  ,
  REGION_OF_BIRTH                ,
  COUNTRY_OF_BIRTH               ,
  GLOBAL_PERSON_ID               ,
  COORD_BEN_MED_PL_NAME          ,
  COORD_BEN_MED_INSR_CRR_NAME    ,
  COORD_BEN_MED_INSR_CRR_IDENT   ,
  COORD_BEN_MED_EXT_ER           ,
  COORD_BEN_MED_CVG_STRT_DT      Date "YYYYMMDD HH24:MI:SS",
  COORD_BEN_MED_CVG_END_DT       Date "YYYYMMDD HH24:MI:SS",
  PARTY_ID                       ,
  NPW_NUMBER                     ,
  CURRENT_NPW_FLAG
)